﻿<%--<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/Manage.Master" AutoEventWireup="true" CodeBehind="MeetingroomManage.aspx.cs" Inherits="UCWebpart.Admin.MeetingroomManage"%>--%>

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MeetingroomManage1.aspx.cs" Inherits="UCWebpart.Admin.MeetingroomManage" %>

<%@ Register Src="~/Admin/MeetingroomUserControl.ascx" TagPrefix="uc1" TagName="MeetingroomUserControl" %>

<%@ Register src="mtrUserControl.ascx" tagname="mtrUserControl" tagprefix="uc2" %>
<%@ Register src="ResourcesUserControl.ascx" tagname="ResourcesUserControl" tagprefix="uc3" %>


<%@ Register src="MeetingroomUserControl1.ascx" tagname="MeetingroomUserControl1" tagprefix="uc4" %>


<!DOCTYPE html>


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>

    <link href="../JS/jquery-ui/css/custom-theme/jquery-ui-1.10.3.custom.css" rel="stylesheet" />

   <script src="../JS/jquery-ui/js/jquery-1.9.1.js"></script>

        <script src="../JS/jquery-ui/js/jquery-ui-1.10.3.custom.js"></script>
        <script src="../JS/jquery-ui-1.10.3.js"></script>

  <link rel="stylesheet" href="/resources/demos/style.css" />
</head>
   
<body >
     <div data-options="region:'center',title:'会议室配置'" style="padding:5px;background:#eee;">
       <form id="form1" runat="server">

           
            <br />
            <br />场地名称：<asp:TextBox ID="mtrName" runat="server" Width="72px"></asp:TextBox>
            &nbsp;场地类型&nbsp;<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="Type" DataValueField="Type">
           </asp:DropDownList>
           <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:meetingroomManagementConnectionString %>" DeleteCommand="DELETE FROM [MTR_bas_Type] WHERE [id] = @id" InsertCommand="INSERT INTO [MTR_bas_Type] ([Type], [available]) VALUES (@Type, @available)" SelectCommand="SELECT * FROM [MTR_bas_Type] WHERE [available] = 'true'" UpdateCommand="UPDATE [MTR_bas_Type] SET [Type] = @Type, [available] = @available WHERE [id] = @id">
               <DeleteParameters>
                   <asp:Parameter Name="id" Type="Int32" />
               </DeleteParameters>
               <InsertParameters>
                   <asp:Parameter Name="Type" Type="String" />
                   <asp:Parameter Name="available" Type="Boolean" />
               </InsertParameters>
               <UpdateParameters>
                   <asp:Parameter Name="Type" Type="String" />
                   <asp:Parameter Name="available" Type="Boolean" />
                   <asp:Parameter Name="id" Type="Int32" />
               </UpdateParameters>
           </asp:SqlDataSource>
           <br />
            来源：公司:<asp:DropDownList ID="mtrCompanyRuc" runat="server" DataSourceID="SqlDataSource1" DataTextField="ABBR" DataValueField="id" OnSelectedIndexChanged="mtrCompanyRuc_SelectedIndexChanged1" OnTextChanged="mtrCompanyRuc_TextChanged" AutoPostBack="True">
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WorkFlowConnectionString %>" 
                SelectCommand="select distinct ABBR,id from [WorkFlow].[dbo].[RUC_Organization](nolock) where OrgTypeID=1 and IfDelete=0 order by id "></asp:SqlDataSource>
            部门:&nbsp;<asp:DropDownList ID="mtrDeptRuc" runat="server" DataSourceID="SqlDataSource3" DataTextField="ABBR" DataValueField="ABBR">
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:WorkFlowConnectionString %>" SelectCommand="select '所有部门' as ABBR,'0' as ID
                union all 
                select ABBR,ID from RUC_Organization(nolock) where IfDelete=0 and ParentID in 
                (select ID from RUC_Organization(nolock) where IfDelete=0 and ParentID in 
                (select ID from RUC_Organization(nolock) where ParentID=@orgID and IfDelete=0 and OrgTypeID=1)) or 
                ParentID in (select ID from RUC_Organization(nolock) where ParentID=@orgID and IfDelete=0 and OrgTypeID=2)
                 ">
                <SelectParameters>
                    <asp:ControlParameter ControlID="mtrCompanyRuc" Name="orgID" PropertyName="SelectedValue" />
                </SelectParameters>
            </asp:SqlDataSource>
            &nbsp; 
            <br />
            场地地址：<asp:DropDownList ID="mtrAddress" runat="server" OnSelectedIndexChanged="mtrAddress_SelectedIndexChanged" DataSourceID="SqlDataSource4" DataTextField="addressName" DataValueField="addressName">
                
                </asp:DropDownList>
             <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:meetingroomManagementConnectionString %>" SelectCommand="SELECT * FROM [VenueBooking].[dbo].[MTR_bas_AddressName] where [available] = '1'"></asp:SqlDataSource>
             <asp:TextBox ID="mtrAddress1" runat="server" Width="109px"></asp:TextBox> <br/>
            容量：<asp:TextBox ID="mtrCap" runat="server" Width="86px"></asp:TextBox>
            &nbsp;&nbsp;
            电话：<asp:TextBox ID="mtrPhone" runat="server" Width="86px"></asp:TextBox>
            类型：<asp:DropDownList ID="mtrType" runat="server">
                <asp:ListItem>VIP</asp:ListItem>
                <asp:ListItem>普通</asp:ListItem>
                       </asp:DropDownList>
            <br />
            最长预定时间：<asp:TextBox ID="mtrLongestBookingDay" runat="server" style="margin-bottom: 0px" Width="119px"></asp:TextBox>
            <br />
            <%--最长提前预定天数<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>--%>
            <br />
            <br />
            <asp:Button ID="add" runat="server" OnClick="Button1_Click" Text="添加" style="height: 21px" />


           <br />
           <br />
           <br />


         </form>  
        </div>
        <div data-options="region:'west',title:'菜单',split:true" style="width:150px;padding:5px;">
       <ul>
          <li><span><a href="MeetingroomManage.aspx ">会议室配置</a></span></li>
            <script>
                 $("#userName").val();
                 $(function () {
                     $("#tabs").tabs();
                 })
             </script>
            <li><span><a href="ResourcesManage.aspx">资源配置</a></span></li>
            <li><span><a href="UserManage.aspx">管理员配置</a></span></li>
            <li><span><a href="OtherManage.aspx">其他配置</a></span></li>
            <li><span><a href="../WEB/BookingManage.aspx">返回前台</a></span></li>
        </ul>
       </div>
    

  <%--  <div id="tabs">
      <ul>
        <li><a href="../WEB/BookingManage.aspx">返回前台</a></li>
        <li><a href="MeetingroomManage.aspx">会议室配置</a></li>
        <li><a href="ResourcesManage.aspx">资源配置</a></li>
        <li><a href="UserManage.aspx">管理员配置</a></li>
      </ul>
      <div id="tabs-1">
        <p>Proin elit arcu, rutrum commodo, vehicula tempus, commodo a, risus. Curabitur nec arcu. Donec sollicitudin mi sit amet mauris. Nam elementum quam ullamcorper ante. Etiam aliquet massa et lorem. Mauris dapibus lacus auctor risus. Aenean tempor ullamcorper leo. Vivamus sed magna quis ligula eleifend adipiscing. Duis orci. Aliquam sodales tortor vitae ipsum. Aliquam nulla. Duis aliquam molestie erat. Ut et mauris vel pede varius sollicitudin. Sed ut dolor nec orci tincidunt interdum. Phasellus ipsum. Nunc tristique tempus lectus.</p>
      </div>
      <div id="tabs-2">
        <p>Morbi tincidunt, dui sit amet facilisis feugiat, odio metus gravida ante, ut pharetra massa metus id nunc. Duis scelerisque molestie turpis. Sed fringilla, massa eget luctus malesuada, metus eros molestie lectus, ut tempus eros massa ut dolor. Aenean aliquet fringilla sem. Suspendisse sed ligula in ligula suscipit aliquam. Praesent in eros vestibulum mi adipiscing adipiscing. Morbi facilisis. Curabitur ornare consequat nunc. Aenean vel metus. Ut posuere viverra nulla. Aliquam erat volutpat. Pellentesque convallis. Maecenas feugiat, tellus pellentesque pretium posuere, felis lorem euismod felis, eu ornare leo nisi vel felis. Mauris consectetur tortor et purus.</p>
      </div>
      <div id="tabs-3">
        <p>Mauris eleifend est et turpis. Duis id erat. Suspendisse potenti. Aliquam vulputate, pede vel vehicula accumsan, mi neque rutrum erat, eu congue orci lorem eget lorem. Vestibulum non ante. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Fusce sodales. Quisque eu urna vel enim commodo pellentesque. Praesent eu risus hendrerit ligula tempus pretium. Curabitur lorem enim, pretium nec, feugiat nec, luctus a, lacus.</p>
        <p>Duis cursus. Maecenas ligula eros, blandit nec, pharetra at, semper at, magna. Nullam ac lacus. Nulla facilisi. Praesent viverra justo vitae neque. Praesent blandit adipiscing velit. Suspendisse potenti. Donec mattis, pede vel pharetra blandit, magna ligula faucibus eros, id euismod lacus dolor eget odio. Nam scelerisque. Donec non libero sed nulla mattis commodo. Ut sagittis. Donec nisi lectus, feugiat porttitor, tempor ac, tempor vitae, pede. Aenean vehicula velit eu tellus interdum rutrum. Maecenas commodo. Pellentesque nec elit. Fusce in lacus. Vivamus a libero vitae lectus hendrerit hendrerit.</p>
      </div>
    </div>
 --%>



    </body>
       
</html>

